How to: Convert a form to a report.
Solution:
In the Form Design view, add the 'Save As Report' to the Toolbar. Click 'Save As Report' for the selected form and type the report name.
1) If the Database window is not activated, activate the Database window.
2) Click the 'Forms' tab in the Database window.
Forms tab
3) Select the desired form from the list box. (The selected form is highlighted.)
4) Click 'Design'. (The selected form appears in Design view, and the floating Toolbox appears.)
5) Select the 'View' menu and select 'Toolbars'. (The Toolbars dialog box appears.)
6) Click 'Customize'. (The Customize Toolbars dialog box appears.)
7) Select the 'Form and Design' topic from the 'Categories' list box.
8) Click on the 'Save Current Form as a Report'.
NOTE: A description of each button appears in the 'Description' box when a button is chosen.
9) Drag-and-drop the 'Save Current Form as a Report' to the Toolbar.
10) Click 'Close'.
11) Click 'Save As Report' on the Toolbar.
12) Type the name for the report.
13) Click 'OK'.
14) Select the 'File' menu and select 'Close'.
15) Click the 'Reports' tab in the Database window.
Reports tab
16) Select the newly created report from the list box. (The selected report is highlighted.)
17) Click 'Preview' to preview the report.
NOTE: The report has the same properties as the form.